package com.base.po.voip;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TourGoodsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TourGoodsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andParentidIsNull() {
            addCriterion("ParentID is null");
            return (Criteria) this;
        }

        public Criteria andParentidIsNotNull() {
            addCriterion("ParentID is not null");
            return (Criteria) this;
        }

        public Criteria andParentidEqualTo(String value) {
            addCriterion("ParentID =", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotEqualTo(String value) {
            addCriterion("ParentID <>", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidGreaterThan(String value) {
            addCriterion("ParentID >", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidGreaterThanOrEqualTo(String value) {
            addCriterion("ParentID >=", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidLessThan(String value) {
            addCriterion("ParentID <", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidLessThanOrEqualTo(String value) {
            addCriterion("ParentID <=", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidLike(String value) {
            addCriterion("ParentID like", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotLike(String value) {
            addCriterion("ParentID not like", value, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidIn(List<String> values) {
            addCriterion("ParentID in", values, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotIn(List<String> values) {
            addCriterion("ParentID not in", values, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidBetween(String value1, String value2) {
            addCriterion("ParentID between", value1, value2, "parentid");
            return (Criteria) this;
        }

        public Criteria andParentidNotBetween(String value1, String value2) {
            addCriterion("ParentID not between", value1, value2, "parentid");
            return (Criteria) this;
        }

        public Criteria andShopidIsNull() {
            addCriterion("ShopID is null");
            return (Criteria) this;
        }

        public Criteria andShopidIsNotNull() {
            addCriterion("ShopID is not null");
            return (Criteria) this;
        }

        public Criteria andShopidEqualTo(String value) {
            addCriterion("ShopID =", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotEqualTo(String value) {
            addCriterion("ShopID <>", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidGreaterThan(String value) {
            addCriterion("ShopID >", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidGreaterThanOrEqualTo(String value) {
            addCriterion("ShopID >=", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLessThan(String value) {
            addCriterion("ShopID <", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLessThanOrEqualTo(String value) {
            addCriterion("ShopID <=", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLike(String value) {
            addCriterion("ShopID like", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotLike(String value) {
            addCriterion("ShopID not like", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidIn(List<String> values) {
            addCriterion("ShopID in", values, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotIn(List<String> values) {
            addCriterion("ShopID not in", values, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidBetween(String value1, String value2) {
            addCriterion("ShopID between", value1, value2, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotBetween(String value1, String value2) {
            addCriterion("ShopID not between", value1, value2, "shopid");
            return (Criteria) this;
        }

        public Criteria andGoodstextIsNull() {
            addCriterion("GoodsText is null");
            return (Criteria) this;
        }

        public Criteria andGoodstextIsNotNull() {
            addCriterion("GoodsText is not null");
            return (Criteria) this;
        }

        public Criteria andGoodstextEqualTo(String value) {
            addCriterion("GoodsText =", value, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextNotEqualTo(String value) {
            addCriterion("GoodsText <>", value, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextGreaterThan(String value) {
            addCriterion("GoodsText >", value, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextGreaterThanOrEqualTo(String value) {
            addCriterion("GoodsText >=", value, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextLessThan(String value) {
            addCriterion("GoodsText <", value, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextLessThanOrEqualTo(String value) {
            addCriterion("GoodsText <=", value, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextLike(String value) {
            addCriterion("GoodsText like", value, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextNotLike(String value) {
            addCriterion("GoodsText not like", value, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextIn(List<String> values) {
            addCriterion("GoodsText in", values, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextNotIn(List<String> values) {
            addCriterion("GoodsText not in", values, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextBetween(String value1, String value2) {
            addCriterion("GoodsText between", value1, value2, "goodstext");
            return (Criteria) this;
        }

        public Criteria andGoodstextNotBetween(String value1, String value2) {
            addCriterion("GoodsText not between", value1, value2, "goodstext");
            return (Criteria) this;
        }

        public Criteria andShowpicIsNull() {
            addCriterion("ShowPic is null");
            return (Criteria) this;
        }

        public Criteria andShowpicIsNotNull() {
            addCriterion("ShowPic is not null");
            return (Criteria) this;
        }

        public Criteria andShowpicEqualTo(String value) {
            addCriterion("ShowPic =", value, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicNotEqualTo(String value) {
            addCriterion("ShowPic <>", value, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicGreaterThan(String value) {
            addCriterion("ShowPic >", value, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicGreaterThanOrEqualTo(String value) {
            addCriterion("ShowPic >=", value, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicLessThan(String value) {
            addCriterion("ShowPic <", value, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicLessThanOrEqualTo(String value) {
            addCriterion("ShowPic <=", value, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicLike(String value) {
            addCriterion("ShowPic like", value, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicNotLike(String value) {
            addCriterion("ShowPic not like", value, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicIn(List<String> values) {
            addCriterion("ShowPic in", values, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicNotIn(List<String> values) {
            addCriterion("ShowPic not in", values, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicBetween(String value1, String value2) {
            addCriterion("ShowPic between", value1, value2, "showpic");
            return (Criteria) this;
        }

        public Criteria andShowpicNotBetween(String value1, String value2) {
            addCriterion("ShowPic not between", value1, value2, "showpic");
            return (Criteria) this;
        }

        public Criteria andDetailpic1IsNull() {
            addCriterion("DetailPic1 is null");
            return (Criteria) this;
        }

        public Criteria andDetailpic1IsNotNull() {
            addCriterion("DetailPic1 is not null");
            return (Criteria) this;
        }

        public Criteria andDetailpic1EqualTo(String value) {
            addCriterion("DetailPic1 =", value, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1NotEqualTo(String value) {
            addCriterion("DetailPic1 <>", value, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1GreaterThan(String value) {
            addCriterion("DetailPic1 >", value, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1GreaterThanOrEqualTo(String value) {
            addCriterion("DetailPic1 >=", value, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1LessThan(String value) {
            addCriterion("DetailPic1 <", value, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1LessThanOrEqualTo(String value) {
            addCriterion("DetailPic1 <=", value, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1Like(String value) {
            addCriterion("DetailPic1 like", value, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1NotLike(String value) {
            addCriterion("DetailPic1 not like", value, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1In(List<String> values) {
            addCriterion("DetailPic1 in", values, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1NotIn(List<String> values) {
            addCriterion("DetailPic1 not in", values, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1Between(String value1, String value2) {
            addCriterion("DetailPic1 between", value1, value2, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic1NotBetween(String value1, String value2) {
            addCriterion("DetailPic1 not between", value1, value2, "detailpic1");
            return (Criteria) this;
        }

        public Criteria andDetailpic2IsNull() {
            addCriterion("DetailPic2 is null");
            return (Criteria) this;
        }

        public Criteria andDetailpic2IsNotNull() {
            addCriterion("DetailPic2 is not null");
            return (Criteria) this;
        }

        public Criteria andDetailpic2EqualTo(String value) {
            addCriterion("DetailPic2 =", value, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2NotEqualTo(String value) {
            addCriterion("DetailPic2 <>", value, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2GreaterThan(String value) {
            addCriterion("DetailPic2 >", value, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2GreaterThanOrEqualTo(String value) {
            addCriterion("DetailPic2 >=", value, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2LessThan(String value) {
            addCriterion("DetailPic2 <", value, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2LessThanOrEqualTo(String value) {
            addCriterion("DetailPic2 <=", value, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2Like(String value) {
            addCriterion("DetailPic2 like", value, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2NotLike(String value) {
            addCriterion("DetailPic2 not like", value, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2In(List<String> values) {
            addCriterion("DetailPic2 in", values, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2NotIn(List<String> values) {
            addCriterion("DetailPic2 not in", values, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2Between(String value1, String value2) {
            addCriterion("DetailPic2 between", value1, value2, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic2NotBetween(String value1, String value2) {
            addCriterion("DetailPic2 not between", value1, value2, "detailpic2");
            return (Criteria) this;
        }

        public Criteria andDetailpic3IsNull() {
            addCriterion("DetailPic3 is null");
            return (Criteria) this;
        }

        public Criteria andDetailpic3IsNotNull() {
            addCriterion("DetailPic3 is not null");
            return (Criteria) this;
        }

        public Criteria andDetailpic3EqualTo(String value) {
            addCriterion("DetailPic3 =", value, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3NotEqualTo(String value) {
            addCriterion("DetailPic3 <>", value, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3GreaterThan(String value) {
            addCriterion("DetailPic3 >", value, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3GreaterThanOrEqualTo(String value) {
            addCriterion("DetailPic3 >=", value, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3LessThan(String value) {
            addCriterion("DetailPic3 <", value, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3LessThanOrEqualTo(String value) {
            addCriterion("DetailPic3 <=", value, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3Like(String value) {
            addCriterion("DetailPic3 like", value, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3NotLike(String value) {
            addCriterion("DetailPic3 not like", value, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3In(List<String> values) {
            addCriterion("DetailPic3 in", values, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3NotIn(List<String> values) {
            addCriterion("DetailPic3 not in", values, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3Between(String value1, String value2) {
            addCriterion("DetailPic3 between", value1, value2, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic3NotBetween(String value1, String value2) {
            addCriterion("DetailPic3 not between", value1, value2, "detailpic3");
            return (Criteria) this;
        }

        public Criteria andDetailpic4IsNull() {
            addCriterion("DetailPic4 is null");
            return (Criteria) this;
        }

        public Criteria andDetailpic4IsNotNull() {
            addCriterion("DetailPic4 is not null");
            return (Criteria) this;
        }

        public Criteria andDetailpic4EqualTo(String value) {
            addCriterion("DetailPic4 =", value, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4NotEqualTo(String value) {
            addCriterion("DetailPic4 <>", value, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4GreaterThan(String value) {
            addCriterion("DetailPic4 >", value, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4GreaterThanOrEqualTo(String value) {
            addCriterion("DetailPic4 >=", value, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4LessThan(String value) {
            addCriterion("DetailPic4 <", value, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4LessThanOrEqualTo(String value) {
            addCriterion("DetailPic4 <=", value, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4Like(String value) {
            addCriterion("DetailPic4 like", value, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4NotLike(String value) {
            addCriterion("DetailPic4 not like", value, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4In(List<String> values) {
            addCriterion("DetailPic4 in", values, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4NotIn(List<String> values) {
            addCriterion("DetailPic4 not in", values, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4Between(String value1, String value2) {
            addCriterion("DetailPic4 between", value1, value2, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailpic4NotBetween(String value1, String value2) {
            addCriterion("DetailPic4 not between", value1, value2, "detailpic4");
            return (Criteria) this;
        }

        public Criteria andDetailvideoIsNull() {
            addCriterion("DetailVideo is null");
            return (Criteria) this;
        }

        public Criteria andDetailvideoIsNotNull() {
            addCriterion("DetailVideo is not null");
            return (Criteria) this;
        }

        public Criteria andDetailvideoEqualTo(String value) {
            addCriterion("DetailVideo =", value, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoNotEqualTo(String value) {
            addCriterion("DetailVideo <>", value, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoGreaterThan(String value) {
            addCriterion("DetailVideo >", value, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoGreaterThanOrEqualTo(String value) {
            addCriterion("DetailVideo >=", value, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoLessThan(String value) {
            addCriterion("DetailVideo <", value, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoLessThanOrEqualTo(String value) {
            addCriterion("DetailVideo <=", value, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoLike(String value) {
            addCriterion("DetailVideo like", value, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoNotLike(String value) {
            addCriterion("DetailVideo not like", value, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoIn(List<String> values) {
            addCriterion("DetailVideo in", values, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoNotIn(List<String> values) {
            addCriterion("DetailVideo not in", values, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoBetween(String value1, String value2) {
            addCriterion("DetailVideo between", value1, value2, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andDetailvideoNotBetween(String value1, String value2) {
            addCriterion("DetailVideo not between", value1, value2, "detailvideo");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyIsNull() {
            addCriterion("FirstClassify is null");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyIsNotNull() {
            addCriterion("FirstClassify is not null");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyEqualTo(String value) {
            addCriterion("FirstClassify =", value, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyNotEqualTo(String value) {
            addCriterion("FirstClassify <>", value, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyGreaterThan(String value) {
            addCriterion("FirstClassify >", value, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyGreaterThanOrEqualTo(String value) {
            addCriterion("FirstClassify >=", value, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyLessThan(String value) {
            addCriterion("FirstClassify <", value, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyLessThanOrEqualTo(String value) {
            addCriterion("FirstClassify <=", value, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyLike(String value) {
            addCriterion("FirstClassify like", value, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyNotLike(String value) {
            addCriterion("FirstClassify not like", value, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyIn(List<String> values) {
            addCriterion("FirstClassify in", values, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyNotIn(List<String> values) {
            addCriterion("FirstClassify not in", values, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyBetween(String value1, String value2) {
            addCriterion("FirstClassify between", value1, value2, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andFirstclassifyNotBetween(String value1, String value2) {
            addCriterion("FirstClassify not between", value1, value2, "firstclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyIsNull() {
            addCriterion("SecondClassify is null");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyIsNotNull() {
            addCriterion("SecondClassify is not null");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyEqualTo(String value) {
            addCriterion("SecondClassify =", value, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyNotEqualTo(String value) {
            addCriterion("SecondClassify <>", value, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyGreaterThan(String value) {
            addCriterion("SecondClassify >", value, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyGreaterThanOrEqualTo(String value) {
            addCriterion("SecondClassify >=", value, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyLessThan(String value) {
            addCriterion("SecondClassify <", value, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyLessThanOrEqualTo(String value) {
            addCriterion("SecondClassify <=", value, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyLike(String value) {
            addCriterion("SecondClassify like", value, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyNotLike(String value) {
            addCriterion("SecondClassify not like", value, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyIn(List<String> values) {
            addCriterion("SecondClassify in", values, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyNotIn(List<String> values) {
            addCriterion("SecondClassify not in", values, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyBetween(String value1, String value2) {
            addCriterion("SecondClassify between", value1, value2, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andSecondclassifyNotBetween(String value1, String value2) {
            addCriterion("SecondClassify not between", value1, value2, "secondclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyIsNull() {
            addCriterion("ThirdClassify is null");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyIsNotNull() {
            addCriterion("ThirdClassify is not null");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyEqualTo(String value) {
            addCriterion("ThirdClassify =", value, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyNotEqualTo(String value) {
            addCriterion("ThirdClassify <>", value, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyGreaterThan(String value) {
            addCriterion("ThirdClassify >", value, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyGreaterThanOrEqualTo(String value) {
            addCriterion("ThirdClassify >=", value, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyLessThan(String value) {
            addCriterion("ThirdClassify <", value, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyLessThanOrEqualTo(String value) {
            addCriterion("ThirdClassify <=", value, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyLike(String value) {
            addCriterion("ThirdClassify like", value, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyNotLike(String value) {
            addCriterion("ThirdClassify not like", value, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyIn(List<String> values) {
            addCriterion("ThirdClassify in", values, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyNotIn(List<String> values) {
            addCriterion("ThirdClassify not in", values, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyBetween(String value1, String value2) {
            addCriterion("ThirdClassify between", value1, value2, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andThirdclassifyNotBetween(String value1, String value2) {
            addCriterion("ThirdClassify not between", value1, value2, "thirdclassify");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("Price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("Price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(BigDecimal value) {
            addCriterion("Price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(BigDecimal value) {
            addCriterion("Price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(BigDecimal value) {
            addCriterion("Price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(BigDecimal value) {
            addCriterion("Price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<BigDecimal> values) {
            addCriterion("Price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<BigDecimal> values) {
            addCriterion("Price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andMemberpriceIsNull() {
            addCriterion("MemberPrice is null");
            return (Criteria) this;
        }

        public Criteria andMemberpriceIsNotNull() {
            addCriterion("MemberPrice is not null");
            return (Criteria) this;
        }

        public Criteria andMemberpriceEqualTo(BigDecimal value) {
            addCriterion("MemberPrice =", value, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceNotEqualTo(BigDecimal value) {
            addCriterion("MemberPrice <>", value, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceGreaterThan(BigDecimal value) {
            addCriterion("MemberPrice >", value, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MemberPrice >=", value, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceLessThan(BigDecimal value) {
            addCriterion("MemberPrice <", value, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MemberPrice <=", value, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceIn(List<BigDecimal> values) {
            addCriterion("MemberPrice in", values, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceNotIn(List<BigDecimal> values) {
            addCriterion("MemberPrice not in", values, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MemberPrice between", value1, value2, "memberprice");
            return (Criteria) this;
        }

        public Criteria andMemberpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MemberPrice not between", value1, value2, "memberprice");
            return (Criteria) this;
        }

        public Criteria andDerateIsNull() {
            addCriterion("Derate is null");
            return (Criteria) this;
        }

        public Criteria andDerateIsNotNull() {
            addCriterion("Derate is not null");
            return (Criteria) this;
        }

        public Criteria andDerateEqualTo(BigDecimal value) {
            addCriterion("Derate =", value, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateNotEqualTo(BigDecimal value) {
            addCriterion("Derate <>", value, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateGreaterThan(BigDecimal value) {
            addCriterion("Derate >", value, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Derate >=", value, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateLessThan(BigDecimal value) {
            addCriterion("Derate <", value, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Derate <=", value, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateIn(List<BigDecimal> values) {
            addCriterion("Derate in", values, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateNotIn(List<BigDecimal> values) {
            addCriterion("Derate not in", values, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Derate between", value1, value2, "derate");
            return (Criteria) this;
        }

        public Criteria andDerateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Derate not between", value1, value2, "derate");
            return (Criteria) this;
        }

        public Criteria andAccountIsNull() {
            addCriterion("Account is null");
            return (Criteria) this;
        }

        public Criteria andAccountIsNotNull() {
            addCriterion("Account is not null");
            return (Criteria) this;
        }

        public Criteria andAccountEqualTo(String value) {
            addCriterion("Account =", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotEqualTo(String value) {
            addCriterion("Account <>", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountGreaterThan(String value) {
            addCriterion("Account >", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountGreaterThanOrEqualTo(String value) {
            addCriterion("Account >=", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLessThan(String value) {
            addCriterion("Account <", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLessThanOrEqualTo(String value) {
            addCriterion("Account <=", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLike(String value) {
            addCriterion("Account like", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotLike(String value) {
            addCriterion("Account not like", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountIn(List<String> values) {
            addCriterion("Account in", values, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotIn(List<String> values) {
            addCriterion("Account not in", values, "account");
            return (Criteria) this;
        }

        public Criteria andAccountBetween(String value1, String value2) {
            addCriterion("Account between", value1, value2, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotBetween(String value1, String value2) {
            addCriterion("Account not between", value1, value2, "account");
            return (Criteria) this;
        }

        public Criteria andIntroduceIsNull() {
            addCriterion("Introduce is null");
            return (Criteria) this;
        }

        public Criteria andIntroduceIsNotNull() {
            addCriterion("Introduce is not null");
            return (Criteria) this;
        }

        public Criteria andIntroduceEqualTo(String value) {
            addCriterion("Introduce =", value, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceNotEqualTo(String value) {
            addCriterion("Introduce <>", value, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceGreaterThan(String value) {
            addCriterion("Introduce >", value, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceGreaterThanOrEqualTo(String value) {
            addCriterion("Introduce >=", value, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceLessThan(String value) {
            addCriterion("Introduce <", value, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceLessThanOrEqualTo(String value) {
            addCriterion("Introduce <=", value, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceLike(String value) {
            addCriterion("Introduce like", value, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceNotLike(String value) {
            addCriterion("Introduce not like", value, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceIn(List<String> values) {
            addCriterion("Introduce in", values, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceNotIn(List<String> values) {
            addCriterion("Introduce not in", values, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceBetween(String value1, String value2) {
            addCriterion("Introduce between", value1, value2, "introduce");
            return (Criteria) this;
        }

        public Criteria andIntroduceNotBetween(String value1, String value2) {
            addCriterion("Introduce not between", value1, value2, "introduce");
            return (Criteria) this;
        }

        public Criteria andContextIsNull() {
            addCriterion("Context is null");
            return (Criteria) this;
        }

        public Criteria andContextIsNotNull() {
            addCriterion("Context is not null");
            return (Criteria) this;
        }

        public Criteria andContextEqualTo(String value) {
            addCriterion("Context =", value, "context");
            return (Criteria) this;
        }

        public Criteria andContextNotEqualTo(String value) {
            addCriterion("Context <>", value, "context");
            return (Criteria) this;
        }

        public Criteria andContextGreaterThan(String value) {
            addCriterion("Context >", value, "context");
            return (Criteria) this;
        }

        public Criteria andContextGreaterThanOrEqualTo(String value) {
            addCriterion("Context >=", value, "context");
            return (Criteria) this;
        }

        public Criteria andContextLessThan(String value) {
            addCriterion("Context <", value, "context");
            return (Criteria) this;
        }

        public Criteria andContextLessThanOrEqualTo(String value) {
            addCriterion("Context <=", value, "context");
            return (Criteria) this;
        }

        public Criteria andContextLike(String value) {
            addCriterion("Context like", value, "context");
            return (Criteria) this;
        }

        public Criteria andContextNotLike(String value) {
            addCriterion("Context not like", value, "context");
            return (Criteria) this;
        }

        public Criteria andContextIn(List<String> values) {
            addCriterion("Context in", values, "context");
            return (Criteria) this;
        }

        public Criteria andContextNotIn(List<String> values) {
            addCriterion("Context not in", values, "context");
            return (Criteria) this;
        }

        public Criteria andContextBetween(String value1, String value2) {
            addCriterion("Context between", value1, value2, "context");
            return (Criteria) this;
        }

        public Criteria andContextNotBetween(String value1, String value2) {
            addCriterion("Context not between", value1, value2, "context");
            return (Criteria) this;
        }

        public Criteria andStandardIsNull() {
            addCriterion("Standard is null");
            return (Criteria) this;
        }

        public Criteria andStandardIsNotNull() {
            addCriterion("Standard is not null");
            return (Criteria) this;
        }

        public Criteria andStandardEqualTo(String value) {
            addCriterion("Standard =", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotEqualTo(String value) {
            addCriterion("Standard <>", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardGreaterThan(String value) {
            addCriterion("Standard >", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardGreaterThanOrEqualTo(String value) {
            addCriterion("Standard >=", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLessThan(String value) {
            addCriterion("Standard <", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLessThanOrEqualTo(String value) {
            addCriterion("Standard <=", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardLike(String value) {
            addCriterion("Standard like", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotLike(String value) {
            addCriterion("Standard not like", value, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardIn(List<String> values) {
            addCriterion("Standard in", values, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotIn(List<String> values) {
            addCriterion("Standard not in", values, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardBetween(String value1, String value2) {
            addCriterion("Standard between", value1, value2, "standard");
            return (Criteria) this;
        }

        public Criteria andStandardNotBetween(String value1, String value2) {
            addCriterion("Standard not between", value1, value2, "standard");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("Status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("Status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Byte value) {
            addCriterion("Status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Byte value) {
            addCriterion("Status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Byte value) {
            addCriterion("Status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Byte value) {
            addCriterion("Status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Byte value) {
            addCriterion("Status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Byte value) {
            addCriterion("Status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Byte> values) {
            addCriterion("Status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Byte> values) {
            addCriterion("Status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Byte value1, Byte value2) {
            addCriterion("Status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Byte value1, Byte value2) {
            addCriterion("Status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDetailslinkIsNull() {
            addCriterion("DetailsLink is null");
            return (Criteria) this;
        }

        public Criteria andDetailslinkIsNotNull() {
            addCriterion("DetailsLink is not null");
            return (Criteria) this;
        }

        public Criteria andDetailslinkEqualTo(String value) {
            addCriterion("DetailsLink =", value, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkNotEqualTo(String value) {
            addCriterion("DetailsLink <>", value, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkGreaterThan(String value) {
            addCriterion("DetailsLink >", value, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkGreaterThanOrEqualTo(String value) {
            addCriterion("DetailsLink >=", value, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkLessThan(String value) {
            addCriterion("DetailsLink <", value, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkLessThanOrEqualTo(String value) {
            addCriterion("DetailsLink <=", value, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkLike(String value) {
            addCriterion("DetailsLink like", value, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkNotLike(String value) {
            addCriterion("DetailsLink not like", value, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkIn(List<String> values) {
            addCriterion("DetailsLink in", values, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkNotIn(List<String> values) {
            addCriterion("DetailsLink not in", values, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkBetween(String value1, String value2) {
            addCriterion("DetailsLink between", value1, value2, "detailslink");
            return (Criteria) this;
        }

        public Criteria andDetailslinkNotBetween(String value1, String value2) {
            addCriterion("DetailsLink not between", value1, value2, "detailslink");
            return (Criteria) this;
        }

        public Criteria andExchangeIsNull() {
            addCriterion("Exchange is null");
            return (Criteria) this;
        }

        public Criteria andExchangeIsNotNull() {
            addCriterion("Exchange is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeEqualTo(String value) {
            addCriterion("Exchange =", value, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeNotEqualTo(String value) {
            addCriterion("Exchange <>", value, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeGreaterThan(String value) {
            addCriterion("Exchange >", value, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeGreaterThanOrEqualTo(String value) {
            addCriterion("Exchange >=", value, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeLessThan(String value) {
            addCriterion("Exchange <", value, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeLessThanOrEqualTo(String value) {
            addCriterion("Exchange <=", value, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeLike(String value) {
            addCriterion("Exchange like", value, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeNotLike(String value) {
            addCriterion("Exchange not like", value, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeIn(List<String> values) {
            addCriterion("Exchange in", values, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeNotIn(List<String> values) {
            addCriterion("Exchange not in", values, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeBetween(String value1, String value2) {
            addCriterion("Exchange between", value1, value2, "exchange");
            return (Criteria) this;
        }

        public Criteria andExchangeNotBetween(String value1, String value2) {
            addCriterion("Exchange not between", value1, value2, "exchange");
            return (Criteria) this;
        }

        public Criteria andDatastatusIsNull() {
            addCriterion("DataStatus is null");
            return (Criteria) this;
        }

        public Criteria andDatastatusIsNotNull() {
            addCriterion("DataStatus is not null");
            return (Criteria) this;
        }

        public Criteria andDatastatusEqualTo(Byte value) {
            addCriterion("DataStatus =", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotEqualTo(Byte value) {
            addCriterion("DataStatus <>", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusGreaterThan(Byte value) {
            addCriterion("DataStatus >", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusGreaterThanOrEqualTo(Byte value) {
            addCriterion("DataStatus >=", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusLessThan(Byte value) {
            addCriterion("DataStatus <", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusLessThanOrEqualTo(Byte value) {
            addCriterion("DataStatus <=", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusIn(List<Byte> values) {
            addCriterion("DataStatus in", values, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotIn(List<Byte> values) {
            addCriterion("DataStatus not in", values, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusBetween(Byte value1, Byte value2) {
            addCriterion("DataStatus between", value1, value2, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotBetween(Byte value1, Byte value2) {
            addCriterion("DataStatus not between", value1, value2, "datastatus");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("CreateTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("CreateTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("CreateTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CreateTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("CreateTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("CreateTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("CreateTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("CreateTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("CreateTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("CreateTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andShelftimeIsNull() {
            addCriterion("ShelfTime is null");
            return (Criteria) this;
        }

        public Criteria andShelftimeIsNotNull() {
            addCriterion("ShelfTime is not null");
            return (Criteria) this;
        }

        public Criteria andShelftimeEqualTo(Date value) {
            addCriterion("ShelfTime =", value, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeNotEqualTo(Date value) {
            addCriterion("ShelfTime <>", value, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeGreaterThan(Date value) {
            addCriterion("ShelfTime >", value, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ShelfTime >=", value, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeLessThan(Date value) {
            addCriterion("ShelfTime <", value, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeLessThanOrEqualTo(Date value) {
            addCriterion("ShelfTime <=", value, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeIn(List<Date> values) {
            addCriterion("ShelfTime in", values, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeNotIn(List<Date> values) {
            addCriterion("ShelfTime not in", values, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeBetween(Date value1, Date value2) {
            addCriterion("ShelfTime between", value1, value2, "shelftime");
            return (Criteria) this;
        }

        public Criteria andShelftimeNotBetween(Date value1, Date value2) {
            addCriterion("ShelfTime not between", value1, value2, "shelftime");
            return (Criteria) this;
        }

        public Criteria andIsgoodsIsNull() {
            addCriterion("IsGoods is null");
            return (Criteria) this;
        }

        public Criteria andIsgoodsIsNotNull() {
            addCriterion("IsGoods is not null");
            return (Criteria) this;
        }

        public Criteria andIsgoodsEqualTo(Byte value) {
            addCriterion("IsGoods =", value, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsNotEqualTo(Byte value) {
            addCriterion("IsGoods <>", value, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsGreaterThan(Byte value) {
            addCriterion("IsGoods >", value, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsGreaterThanOrEqualTo(Byte value) {
            addCriterion("IsGoods >=", value, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsLessThan(Byte value) {
            addCriterion("IsGoods <", value, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsLessThanOrEqualTo(Byte value) {
            addCriterion("IsGoods <=", value, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsIn(List<Byte> values) {
            addCriterion("IsGoods in", values, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsNotIn(List<Byte> values) {
            addCriterion("IsGoods not in", values, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsBetween(Byte value1, Byte value2) {
            addCriterion("IsGoods between", value1, value2, "isgoods");
            return (Criteria) this;
        }

        public Criteria andIsgoodsNotBetween(Byte value1, Byte value2) {
            addCriterion("IsGoods not between", value1, value2, "isgoods");
            return (Criteria) this;
        }

        public Criteria andStockIsNull() {
            addCriterion("Stock is null");
            return (Criteria) this;
        }

        public Criteria andStockIsNotNull() {
            addCriterion("Stock is not null");
            return (Criteria) this;
        }

        public Criteria andStockEqualTo(Integer value) {
            addCriterion("Stock =", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockNotEqualTo(Integer value) {
            addCriterion("Stock <>", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockGreaterThan(Integer value) {
            addCriterion("Stock >", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockGreaterThanOrEqualTo(Integer value) {
            addCriterion("Stock >=", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockLessThan(Integer value) {
            addCriterion("Stock <", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockLessThanOrEqualTo(Integer value) {
            addCriterion("Stock <=", value, "stock");
            return (Criteria) this;
        }

        public Criteria andStockIn(List<Integer> values) {
            addCriterion("Stock in", values, "stock");
            return (Criteria) this;
        }

        public Criteria andStockNotIn(List<Integer> values) {
            addCriterion("Stock not in", values, "stock");
            return (Criteria) this;
        }

        public Criteria andStockBetween(Integer value1, Integer value2) {
            addCriterion("Stock between", value1, value2, "stock");
            return (Criteria) this;
        }

        public Criteria andStockNotBetween(Integer value1, Integer value2) {
            addCriterion("Stock not between", value1, value2, "stock");
            return (Criteria) this;
        }

        public Criteria andSellIsNull() {
            addCriterion("Sell is null");
            return (Criteria) this;
        }

        public Criteria andSellIsNotNull() {
            addCriterion("Sell is not null");
            return (Criteria) this;
        }

        public Criteria andSellEqualTo(Integer value) {
            addCriterion("Sell =", value, "sell");
            return (Criteria) this;
        }

        public Criteria andSellNotEqualTo(Integer value) {
            addCriterion("Sell <>", value, "sell");
            return (Criteria) this;
        }

        public Criteria andSellGreaterThan(Integer value) {
            addCriterion("Sell >", value, "sell");
            return (Criteria) this;
        }

        public Criteria andSellGreaterThanOrEqualTo(Integer value) {
            addCriterion("Sell >=", value, "sell");
            return (Criteria) this;
        }

        public Criteria andSellLessThan(Integer value) {
            addCriterion("Sell <", value, "sell");
            return (Criteria) this;
        }

        public Criteria andSellLessThanOrEqualTo(Integer value) {
            addCriterion("Sell <=", value, "sell");
            return (Criteria) this;
        }

        public Criteria andSellIn(List<Integer> values) {
            addCriterion("Sell in", values, "sell");
            return (Criteria) this;
        }

        public Criteria andSellNotIn(List<Integer> values) {
            addCriterion("Sell not in", values, "sell");
            return (Criteria) this;
        }

        public Criteria andSellBetween(Integer value1, Integer value2) {
            addCriterion("Sell between", value1, value2, "sell");
            return (Criteria) this;
        }

        public Criteria andSellNotBetween(Integer value1, Integer value2) {
            addCriterion("Sell not between", value1, value2, "sell");
            return (Criteria) this;
        }

        public Criteria andNumidIsNull() {
            addCriterion("NumID is null");
            return (Criteria) this;
        }

        public Criteria andNumidIsNotNull() {
            addCriterion("NumID is not null");
            return (Criteria) this;
        }

        public Criteria andNumidEqualTo(Integer value) {
            addCriterion("NumID =", value, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidNotEqualTo(Integer value) {
            addCriterion("NumID <>", value, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidGreaterThan(Integer value) {
            addCriterion("NumID >", value, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidGreaterThanOrEqualTo(Integer value) {
            addCriterion("NumID >=", value, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidLessThan(Integer value) {
            addCriterion("NumID <", value, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidLessThanOrEqualTo(Integer value) {
            addCriterion("NumID <=", value, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidIn(List<Integer> values) {
            addCriterion("NumID in", values, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidNotIn(List<Integer> values) {
            addCriterion("NumID not in", values, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidBetween(Integer value1, Integer value2) {
            addCriterion("NumID between", value1, value2, "numid");
            return (Criteria) this;
        }

        public Criteria andNumidNotBetween(Integer value1, Integer value2) {
            addCriterion("NumID not between", value1, value2, "numid");
            return (Criteria) this;
        }

        public Criteria andColorIsNull() {
            addCriterion("Color is null");
            return (Criteria) this;
        }

        public Criteria andColorIsNotNull() {
            addCriterion("Color is not null");
            return (Criteria) this;
        }

        public Criteria andColorEqualTo(String value) {
            addCriterion("Color =", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotEqualTo(String value) {
            addCriterion("Color <>", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorGreaterThan(String value) {
            addCriterion("Color >", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorGreaterThanOrEqualTo(String value) {
            addCriterion("Color >=", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLessThan(String value) {
            addCriterion("Color <", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLessThanOrEqualTo(String value) {
            addCriterion("Color <=", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorLike(String value) {
            addCriterion("Color like", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotLike(String value) {
            addCriterion("Color not like", value, "color");
            return (Criteria) this;
        }

        public Criteria andColorIn(List<String> values) {
            addCriterion("Color in", values, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotIn(List<String> values) {
            addCriterion("Color not in", values, "color");
            return (Criteria) this;
        }

        public Criteria andColorBetween(String value1, String value2) {
            addCriterion("Color between", value1, value2, "color");
            return (Criteria) this;
        }

        public Criteria andColorNotBetween(String value1, String value2) {
            addCriterion("Color not between", value1, value2, "color");
            return (Criteria) this;
        }

        public Criteria andSupplierIsNull() {
            addCriterion("Supplier is null");
            return (Criteria) this;
        }

        public Criteria andSupplierIsNotNull() {
            addCriterion("Supplier is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierEqualTo(String value) {
            addCriterion("Supplier =", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierNotEqualTo(String value) {
            addCriterion("Supplier <>", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierGreaterThan(String value) {
            addCriterion("Supplier >", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierGreaterThanOrEqualTo(String value) {
            addCriterion("Supplier >=", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierLessThan(String value) {
            addCriterion("Supplier <", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierLessThanOrEqualTo(String value) {
            addCriterion("Supplier <=", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierLike(String value) {
            addCriterion("Supplier like", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierNotLike(String value) {
            addCriterion("Supplier not like", value, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierIn(List<String> values) {
            addCriterion("Supplier in", values, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierNotIn(List<String> values) {
            addCriterion("Supplier not in", values, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierBetween(String value1, String value2) {
            addCriterion("Supplier between", value1, value2, "supplier");
            return (Criteria) this;
        }

        public Criteria andSupplierNotBetween(String value1, String value2) {
            addCriterion("Supplier not between", value1, value2, "supplier");
            return (Criteria) this;
        }

        public Criteria andSizeIsNull() {
            addCriterion("Size is null");
            return (Criteria) this;
        }

        public Criteria andSizeIsNotNull() {
            addCriterion("Size is not null");
            return (Criteria) this;
        }

        public Criteria andSizeEqualTo(String value) {
            addCriterion("Size =", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeNotEqualTo(String value) {
            addCriterion("Size <>", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeGreaterThan(String value) {
            addCriterion("Size >", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeGreaterThanOrEqualTo(String value) {
            addCriterion("Size >=", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeLessThan(String value) {
            addCriterion("Size <", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeLessThanOrEqualTo(String value) {
            addCriterion("Size <=", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeLike(String value) {
            addCriterion("Size like", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeNotLike(String value) {
            addCriterion("Size not like", value, "size");
            return (Criteria) this;
        }

        public Criteria andSizeIn(List<String> values) {
            addCriterion("Size in", values, "size");
            return (Criteria) this;
        }

        public Criteria andSizeNotIn(List<String> values) {
            addCriterion("Size not in", values, "size");
            return (Criteria) this;
        }

        public Criteria andSizeBetween(String value1, String value2) {
            addCriterion("Size between", value1, value2, "size");
            return (Criteria) this;
        }

        public Criteria andSizeNotBetween(String value1, String value2) {
            addCriterion("Size not between", value1, value2, "size");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}